CREATE TABLE [dbo].[tr_Project](
	[ProjectId] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[Name] [varchar](max) NOT NULL,
	[Description] [varchar](max) NULL,
	[ActiveInd] [bit] NOT NULL,
	[DeletedInd] [bit] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tr_Project] ADD  CONSTRAINT [DF_tr_Project_ProjectId]  DEFAULT (newid()) FOR [ProjectId]
GO

ALTER TABLE [dbo].[tr_Project] ADD  CONSTRAINT [DF_tr_Project_ActiveInd]  DEFAULT ((0)) FOR [ActiveInd]
GO

ALTER TABLE [dbo].[tr_Project] ADD  CONSTRAINT [DF_tr_Project_DeletedInd]  DEFAULT ((0)) FOR [DeletedInd]
GO


